package com.twh.www.mapper;

import com.twh.www.entity.WnUser;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
* @author 谭万豪
* @description 针对表【wn_user】的数据库操作Mapper
* @createDate 2025-04-24 21:56:03
* @Entity com.twh.www.entity.WnUser
*/
@Mapper
public interface WnUserMapper extends BaseMapper<WnUser> {
    @Select("SELECT * FROM wn_user WHERE account = #{account}")
    WnUser getUserByAccount(String account);

    @Select("SELECT * FROM wn_user WHERE telphone = #{phone}")
    WnUser getUserByPhone(String phone);

    @Select("SELECT * FROM wn_user WHERE email = #{email}")
    WnUser getUserByEmail(String email);
}




